Column and Row Expressions
Cube views accept calculated columns and rows using the GetDataCell function and references to cube view column and row names. This is known as Column/Row math.
Write column and row expressions in the cube view row or column itself. They calculate at runtime.
These expressions require a reference to the specific cube view column or row name to return a data point.
Use column and row expressions if you need to perform math across columns and rows. A common use case is with variance columns. Column and row expressions are useful if the query is more complex or if the expression is easy to understand and maintain.
NOTE: Use one of the other expression types if you are using multiple member expansions, especially when performing math on rows.